package com.aliyun.heiyu.powermaster.server.dao;

import java.util.Date;
import java.util.List;
import java.util.Map;

public interface EnergyViewProviderDao {

    Map<String, String> findBusinessIds();

    Map<String, String> findGpuSNs();

    boolean insertServerAmount(String business, int cpu_amount, int gpu_amount, int server_amount, Date collect_time, int business_id);

    List<Map<String, String>> findServerModelAmount(int business_id, String startTime, String endTime);

    List<Map<String, String>> findAirRecommendTemp(String startTime,String endTime);

    Map<String, String> totalServerAmount();

    boolean insertEnergyEfficiencyRatio(double energy_efficiency_ratio, String start_time, String end_time,String cycle);

    List<Map<String, String>> findEnergyEfficiencyRatioByCycle(String cycle);

    Map<String, String> findIpBySn(String sn);

    Map<String, String> findStrategyIdBySn(String sn);

    Map<String, String> findStrategyNameById(String id);

    List<Map<String, String>> findQpsByBusiness(Integer business_id, String startTime, String endTime);

    Map<String, String> findAvgQps(String startTime,String endTime);

    Map<String, String> findAvgEer(String collectTimeStart,String collectTimeEnd,String cycle);

    Map<String, String> findBusinessInfos(String business_id);

}
